package com.health.dao;

import com.health.utils.ConnectionUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;

public class UsersExamineDao {

    //删除套餐
    public int deleteUsers_Examine(int Uid, int Eid, String time) {
        int resultLine = 0;
        try {
            Connection connection = ConnectionUtil.getConnection();
            String sqladd = "delete  from users_examine where user_id=? and examine_id=? and examine_date=?";
            PreparedStatement preparedStatement = connection.prepareStatement(sqladd);
            preparedStatement.setInt(1, Uid);
            preparedStatement.setInt(2, Eid);
            preparedStatement.setString(3, time);
            resultLine = preparedStatement.executeUpdate();
            System.out.println(Uid);
            System.out.println(Eid);
            System.out.println(time);
            System.out.println(resultLine);
        } catch (Exception e) {
            e.printStackTrace();

        }

        return resultLine;


    }
}
